package com.sefon.smarteconomy.domain;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.Id;
 
/**
 * 
 * Copyright: Copyright (c) 2018 SefonSoft 
 * 
 * @ClassName: User.java 
 * @Description:客户基本信息
 * 
 * @version: v1.0.0
 * @author: SF2170
 * @by AnalysisExcel2File.java
 * @Date 2018/03/26 22:07:28
 * 
 */
@Entity
@Table(name="client")
public class Client {

	/**
	* 递增 1000开始 (看不懂视频中的规律，但是需要展示出来，使用数字较好)
	*/
	@Id 
	@Column(name="`id`", length=10, columnDefinition="bigint(10) COMMENT '客户id'")
	private Long id;

	@Column(name="`name`", nullable=false, length=255, columnDefinition="varchar(255) COMMENT '姓名'")
	private String name;

	/**
	* 0，1，-1(1:男 , 0:女 ，-1：未知)
	*/
	@Column(name="`sex`", length=2, columnDefinition="int(2) COMMENT '性别'")
	private Integer sex;

	@Column(name="`age`", length=3, columnDefinition="int(3) COMMENT '年龄'")
	private Integer age;

	@Column(name="`card_no`", length=25, columnDefinition="varchar(25) COMMENT '身份证号'")
	private String cardNo;

	@Column(name="`phone`", length=64, columnDefinition="varchar(64) COMMENT '手机'")
	private String phone;

	/**
	* （基础表中300-399）如果超过100+ 采用扩充 即 300001 目前看不会超过
	*/
	@Column(name="`bank`", columnDefinition="int COMMENT '开户银行'")
	private Integer bank;

	/**
	* 用于排序
	*/
	@Column(name="`create_date`", columnDefinition="datetime COMMENT '创建时间'")
	private Date createDate;

	/**
	* 不知道有啥用 ，先留着吧
	*/
	@Column(name="`update_data`", columnDefinition="timestamp COMMENT '修改时间'")
	private Date updateData;

	/**
	* 0和1(1:true ,0:false)
	*/
	@Column(name="`del_flag`", length=2, columnDefinition="int(2) COMMENT '删除标记（做逻辑删除）'")
	private Integer delFlag;


	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Integer getSex() {
		return sex;
	}

	public void setSex(Integer sex) {
		this.sex = sex;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	public String getCardNo() {
		return cardNo;
	}

	public void setCardNo(String cardNo) {
		this.cardNo = cardNo;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}

	public Integer getBank() {
		return bank;
	}

	public void setBank(Integer bank) {
		this.bank = bank;
	}

	public Date getCreateDate() {
		return createDate;
	}

	public void setCreateDate(Date createDate) {
		this.createDate = createDate;
	}

	public Date getUpdateData() {
		return updateData;
	}

	public void setUpdateData(Date updateData) {
		this.updateData = updateData;
	}

	public Integer getDelFlag() {
		return delFlag;
	}

	public void setDelFlag(Integer delFlag) {
		this.delFlag = delFlag;
	}

}
